Pandas Profiling Report

Dataset statistics

Number of variables	41
Number of observations	416198
Missing cells	882896
Missing cells (%)	5.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	130.2 MiB
Average record size in memory	328.0 B

Variable types

CAT	23
NUM	15
BOOL	3

Reproduction

Analysis started	2020-07-06 14:13:38.578395
Analysis finished	2020-07-06 14:16:05.130988
Duration	2 minutes and 26.55 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`RD_NO` has a high cardinality: 412429 distinct values	High cardinality
`CRASH_DATE` has a high cardinality: 269126 distinct values	High cardinality
`DATE_POLICE_NOTIFIED` has a high cardinality: 318866 distinct values	High cardinality
`STREET_NAME` has a high cardinality: 1549 distinct values	High cardinality
`LOCATION` has a high cardinality: 188585 distinct values	High cardinality
`LONGITUDE` is highly correlated with `LATITUDE`	High correlation
`LATITUDE` is highly correlated with `LONGITUDE`	High correlation
`LANE_CNT` has 217643 (52.3%) missing values	Missing
`REPORT_TYPE` has 9854 (2.4%) missing values	Missing
`INTERSECTION_RELATED_I` has 323233 (77.7%) missing values	Missing
`HIT_AND_RUN_I` has 298508 (71.7%) missing values	Missing
`LANE_CNT` is highly skewed (γ1 = 349.9037887)	Skewed
`LATITUDE` is highly skewed (γ1 = -109.5963231)	Skewed
`LONGITUDE` is highly skewed (γ1 = 118.3356283)	Skewed
`RD_NO` is uniformly distributed	Uniform
`CRASH_DATE` is uniformly distributed	Uniform
`DATE_POLICE_NOTIFIED` is uniformly distributed	Uniform
`CRASH_RECORD_ID` has unique values	Unique
`POSTED_SPEED_LIMIT` has 6598 (1.6%) zeros	Zeros
`LANE_CNT` has 8011 (1.9%) zeros	Zeros
`INJURIES_TOTAL` has 362531 (87.1%) zeros	Zeros
`INJURIES_INCAPACITATING` has 407047 (97.8%) zeros	Zeros
`INJURIES_NON_INCAPACITATING` has 384446 (92.4%) zeros	Zeros
`INJURIES_REPORTED_NOT_EVIDENT` has 395564 (95.0%) zeros	Zeros
`INJURIES_NO_INDICATION` has 7217 (1.7%) zeros	Zeros
`CRASH_HOUR` has 7955 (1.9%) zeros	Zeros

CRASH_RECORD_ID
Categorical

UNIQUE

Distinct count	416198
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

f15dd1b39f7524eb37e04fd1b543c4550722caceacd2bf34021cd6857a21038688c3156a48a306cecf929176acbe2ec703d3e00388a4ab30c34001c80367b831	1
1be2eecc95ba0fbb145bce867b6f21e6c7c9a3fcb31208aa3d2fa20fe12a7c5cf8eeaae24389026cd065ef7b1e03795f660fb229206ff2c5a97a5a3d480a38ec	1
554d9ce368e66c697ea20c679fca1c2a18e5822a3a49964231e43aa0a1a9cac1f3cef6b7e88b955eda8e1aebb0c749a01b151577903fbcac0363b09ee529bdf2	1
2cd9ef75712e240e93d4dda66a1a8777a0d73660996f73a6481ff2ec5502c47b27942936d4c64b4dfc59b645010e9c9c823152e1c7401e4d214f0e65b260ba1c	1
355299096b6010f84ce85a7839179b7346793149c614ae79c0403fe09e2e5f31500c63607512885ffec9bd1883c1d07a11058f784a761e46ac6ba655a32bc8b1	1
Other values (416193)	416193

Common Values
Length

Value	Count	Frequency (%)
f15dd1b39f7524eb37e04fd1b543c4550722caceacd2bf34021cd6857a21038688c3156a48a306cecf929176acbe2ec703d3e00388a4ab30c34001c80367b831	1	< 0.1%
1be2eecc95ba0fbb145bce867b6f21e6c7c9a3fcb31208aa3d2fa20fe12a7c5cf8eeaae24389026cd065ef7b1e03795f660fb229206ff2c5a97a5a3d480a38ec	1	< 0.1%
554d9ce368e66c697ea20c679fca1c2a18e5822a3a49964231e43aa0a1a9cac1f3cef6b7e88b955eda8e1aebb0c749a01b151577903fbcac0363b09ee529bdf2	1	< 0.1%
2cd9ef75712e240e93d4dda66a1a8777a0d73660996f73a6481ff2ec5502c47b27942936d4c64b4dfc59b645010e9c9c823152e1c7401e4d214f0e65b260ba1c	1	< 0.1%
355299096b6010f84ce85a7839179b7346793149c614ae79c0403fe09e2e5f31500c63607512885ffec9bd1883c1d07a11058f784a761e46ac6ba655a32bc8b1	1	< 0.1%
e362d43c64ae3ca4172851659d5744a7b95701589a43a3bee036a27904cd112bf685d08f725dd72c16830d10d534e97ae0910a2a25b9f9cb1a983d7a1de60d6f	1	< 0.1%
f9cc1acdd334027a374d7d2dbe91f751b6fdcc88b44bf8f7a7535b97c5b6a9d3bf283b2d3a662c85b5dd46843e89cc6d4e1f9652fdf8a9b6da30c18e50157ad2	1	< 0.1%
62a80219868d83f66c9ebe89f04aab8322454250e8cbf2efdd01ec8beb6f305e27e6506789e39c051a3fa27bbb8a27d18ff124813c66f0a9a266ee72f6dd3d02	1	< 0.1%
f81b2af19bda5e335a2b8e6a3d80838b46e791b9df54698e450bcb8980cb5a8c2168fb62468b3ccc4c76eaeb3aa93052bd9182db52e1ab5dda3c259f6dffeac5	1	< 0.1%
5ece44b15c211231a91804b0e7566af4fcfed70639b184b4e8ffb66c93e06ea6a7e7c82f1dc8509804554d64824475da2c641c1266c1d01aef8abc354a2a225a	1	< 0.1%
Other values (416188)	416188	> 99.9%

Length

Max length	128
Median length	128
Mean length	128
Min length	128

RD_NO
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	412429
Unique (%)	100.0%
Missing	3769
Missing (%)	0.9%
Memory size	3.2 MiB

JB542414	1
JC342313	1
JB420157	1
JB544230	1
JB491934	1
Other values (412424)	412424

Common Values
Length

Value	Count	Frequency (%)
JB542414	1	< 0.1%
JC342313	1	< 0.1%
JB420157	1	< 0.1%
JB544230	1	< 0.1%
JB491934	1	< 0.1%
JC161138	1	< 0.1%
JC463125	1	< 0.1%
JB350707	1	< 0.1%
HZ359951	1	< 0.1%
JB150690	1	< 0.1%
Other values (412419)	412419	99.1%
(Missing)	3769	0.9%

Length

Max length	8
Median length	8
Mean length	7.95472107
Min length	3

CRASH_DATE
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	269126
Unique (%)	64.7%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

11/10/2017 10:30:00 AM	27
11/10/2017 10:00:00 AM	20
01/12/2019 02:30:00 PM	20
01/12/2019 02:00:00 PM	18
01/12/2019 03:00:00 PM	18
Other values (269121)	416095

Common Values
Length

Value	Count	Frequency (%)
11/10/2017 10:30:00 AM	27	< 0.1%
11/10/2017 10:00:00 AM	20	< 0.1%
01/12/2019 02:30:00 PM	20	< 0.1%
01/12/2019 02:00:00 PM	18	< 0.1%
01/12/2019 03:00:00 PM	18	< 0.1%
02/26/2020 07:45:00 AM	17	< 0.1%
09/04/2018 08:00:00 AM	16	< 0.1%
01/12/2019 04:00:00 PM	16	< 0.1%
02/26/2020 08:00:00 AM	16	< 0.1%
02/10/2019 02:00:00 PM	15	< 0.1%
Other values (269116)	416015	> 99.9%

Length

Max length	22
Median length	22
Mean length	22
Min length	22

POSTED_SPEED_LIMIT
Real number (ℝ_≥0)

ZEROS

Distinct count	42
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	28.262797995184982
Minimum	0
Maximum	99
Zeros	6598
Zeros (%)	1.6%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	30
median	30
Q3	30
95-th percentile	35
Maximum	99
Range	99
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.591077534
Coefficient of variation (CV)	0.2332068302
Kurtosis	8.500474378
Mean	28.262798
Median Absolute Deviation (MAD)	0
Skewness	-1.918221926
Sum	11762920
Variance	43.44230306

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
30	306912	73.7%
35	28469	6.8%
25	24953	6.0%
20	16016	3.8%
15	14243	3.4%
10	8428	2.0%
0	6598	1.6%
40	3739	0.9%
5	3434	0.8%
45	2476	0.6%
Other values (32)	930	0.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6598	1.6%
1	35	< 0.1%
2	19	< 0.1%
3	104	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
99	67	< 0.1%
70	3	< 0.1%
65	9	< 0.1%
63	1	< 0.1%
60	26	< 0.1%

TRAFFIC_CONTROL_DEVICE
Categorical

Distinct count	19
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

NO CONTROLS	239527
TRAFFIC SIGNAL	116124
STOP SIGN/FLASHER	40941
UNKNOWN	13406
OTHER	2497
Other values (14)	3703

Common Values
Length

Value	Count	Frequency (%)
NO CONTROLS	239527	57.6%
TRAFFIC SIGNAL	116124	27.9%
STOP SIGN/FLASHER	40941	9.8%
UNKNOWN	13406	3.2%
OTHER	2497	0.6%
LANE USE MARKING	1224	0.3%
YIELD	595	0.1%
OTHER REG. SIGN	400	0.1%
OTHER WARNING SIGN	369	0.1%
RAILROAD CROSSING GATE	286	0.1%
Other values (9)	829	0.2%

Length

Max length	24
Median length	11
Mean length	12.29793271
Min length	5

DEVICE_CONDITION
Categorical

Distinct count	8
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

NO CONTROLS	241838
FUNCTIONING PROPERLY	144596
UNKNOWN	22621
OTHER	3213
FUNCTIONING IMPROPERLY	2333
Other values (3)	1597

Common Values
Length

Value	Count	Frequency (%)
NO CONTROLS	241838	58.1%
FUNCTIONING PROPERLY	144596	34.7%
UNKNOWN	22621	5.4%
OTHER	3213	0.8%
FUNCTIONING IMPROPERLY	2333	0.6%
NOT FUNCTIONING	1350	0.3%
WORN REFLECTIVE MATERIAL	192	< 0.1%
MISSING	55	< 0.1%

Length

Max length	24
Median length	11
Mean length	13.94316888
Min length	5

WEATHER_CONDITION
Categorical

Distinct count	12
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

CLEAR	328222
RAIN	38322
UNKNOWN	17924
SNOW	15638
CLOUDY/OVERCAST	12782
Other values (7)	3310

Common Values
Length

Value	Count	Frequency (%)
CLEAR	328222	78.9%
RAIN	38322	9.2%
UNKNOWN	17924	4.3%
SNOW	15638	3.8%
CLOUDY/OVERCAST	12782	3.1%
OTHER	1337	0.3%
FOG/SMOKE/HAZE	782	0.2%
SLEET/HAIL	655	0.2%
FREEZING RAIN/DRIZZLE	384	0.1%
SEVERE CROSS WIND GATE	88	< 0.1%
Other values (2)	64	< 0.1%

Length

Max length	24
Median length	5
Mean length	5.307836655
Min length	4

LIGHTING_CONDITION
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

DAYLIGHT	272789
DARKNESS, LIGHTED ROAD	87268
DARKNESS	21134
UNKNOWN	14949
DUSK	12780

Common Values
Length

Value	Count	Frequency (%)
DAYLIGHT	272789	65.5%
DARKNESS, LIGHTED ROAD	87268	21.0%
DARKNESS	21134	5.1%
UNKNOWN	14949	3.6%
DUSK	12780	3.1%
DAWN	7278	1.7%

Length

Max length	22
Median length	8
Mean length	10.70681503
Min length	4

FIRST_CRASH_TYPE
Categorical

Distinct count	18
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

REAR END	101600
PARKED MOTOR VEHICLE	93339
SIDESWIPE SAME DIRECTION	66394
TURNING	58260
ANGLE	43642
Other values (13)	52963

Common Values
Length

Value	Count	Frequency (%)
REAR END	101600	24.4%
PARKED MOTOR VEHICLE	93339	22.4%
SIDESWIPE SAME DIRECTION	66394	16.0%
TURNING	58260	14.0%
ANGLE	43642	10.5%
FIXED OBJECT	18304	4.4%
PEDESTRIAN	9861	2.4%
SIDESWIPE OPPOSITE DIRECTION	6142	1.5%
PEDALCYCLIST	5974	1.4%
OTHER OBJECT	3882	0.9%
Other values (8)	8800	2.1%

Length

Max length	28
Median length	10
Mean length	13.46485807
Min length	5

TRAFFICWAY_TYPE
Categorical

Distinct count	20
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

NOT DIVIDED	187541
DIVIDED - W/MEDIAN (NOT RAISED)	75538
ONE-WAY	55263
PARKING LOT	29929
DIVIDED - W/MEDIAN BARRIER	25175
Other values (15)	42752

Common Values
Length

Value	Count	Frequency (%)
NOT DIVIDED	187541	45.1%
DIVIDED - W/MEDIAN (NOT RAISED)	75538	18.1%
ONE-WAY	55263	13.3%
PARKING LOT	29929	7.2%
DIVIDED - W/MEDIAN BARRIER	25175	6.0%
OTHER	12103	2.9%
FOUR WAY	9384	2.3%
ALLEY	6684	1.6%
UNKNOWN	4556	1.1%
CENTER TURN LANE	3696	0.9%
Other values (10)	6329	1.5%

Length

Max length	31
Median length	11
Mean length	14.67856645
Min length	4

LANE_CNT
Real number (ℝ_≥0)

MISSING
SKEWED
ZEROS

Distinct count	41
Unique (%)	< 0.1%
Missing	217643
Missing (%)	52.3%
Infinite	0
Infinite (%)	0.0%

Mean	13.35549847649266
Minimum	0.0
Maximum	1191625.0
Zeros	8011
Zeros (%)	1.9%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	4
95-th percentile	4
Maximum	1191625
Range	1191625
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2964.985076
Coefficient of variation (CV)	222.004823
Kurtosis	134371.3452
Mean	13.35549848
Median Absolute Deviation (MAD)	1
Skewness	349.9037887
Sum	2651801
Variance	8791136.5

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	90913	21.8%
4	49492	11.9%
1	32500	7.8%
3	8644	2.1%
0	8011	1.9%
6	4494	1.1%
5	1935	0.5%
8	1906	0.5%
7	184	< 0.1%
10	161	< 0.1%
Other values (31)	315	0.1%
(Missing)	217643	52.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8011	1.9%
1	32500	7.8%
2	90913	21.8%
3	8644	2.1%
4	49492	11.9%

Value	Count	Frequency (%)
1191625	1	< 0.1%
433634	1	< 0.1%
299679	1	< 0.1%
218474	1	< 0.1%
902	1	< 0.1%

ALIGNMENT
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

STRAIGHT AND LEVEL	405811
STRAIGHT ON GRADE	5096
CURVE, LEVEL	3126
STRAIGHT ON HILLCREST	1343
CURVE ON GRADE	615

Common Values
Length

Value	Count	Frequency (%)
STRAIGHT AND LEVEL	405811	97.5%
STRAIGHT ON GRADE	5096	1.2%
CURVE, LEVEL	3126	0.8%
STRAIGHT ON HILLCREST	1343	0.3%
CURVE ON GRADE	615	0.1%
CURVE ON HILLCREST	207	< 0.1%

Length

Max length	21
Median length	18
Mean length	17.94646058
Min length	12

ROADWAY_SURFACE_COND
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

DRY	310714
WET	58746
UNKNOWN	27285
SNOW OR SLUSH	14891
ICE	3393
Other values (2)	1169

Common Values
Length

Value	Count	Frequency (%)
DRY	310714	74.7%
WET	58746	14.1%
UNKNOWN	27285	6.6%
SNOW OR SLUSH	14891	3.6%
ICE	3393	0.8%
OTHER	971	0.2%
SAND, MUD, DIRT	198	< 0.1%

Length

Max length	15
Median length	3
Mean length	3.630392265
Min length	3

ROAD_DEFECT
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

NO DEFECTS	346941
UNKNOWN	59680
RUT, HOLES	4187
OTHER	2395
WORN SURFACE	1709
Other values (2)	1286

Common Values
Length

Value	Count	Frequency (%)
NO DEFECTS	346941	83.4%
UNKNOWN	59680	14.3%
RUT, HOLES	4187	1.0%
OTHER	2395	0.6%
WORN SURFACE	1709	0.4%
SHOULDER DEFECT	910	0.2%
DEBRIS ON ROADWAY	376	0.1%

Length

Max length	17
Median length	10
Mean length	9.566516418
Min length	5

REPORT_TYPE
Categorical

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	9854
Missing (%)	2.4%
Memory size	3.2 MiB

NOT ON SCENE (DESK REPORT)	247133
ON SCENE	159211

Common Values
Length

Value	Count	Frequency (%)
NOT ON SCENE (DESK REPORT)	247133	59.4%
ON SCENE	159211	38.3%
(Missing)	9854	2.4%

Length

Max length	26
Median length	26
Mean length	18.5697865
Min length	3

CRASH_TYPE
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

NO INJURY / DRIVE AWAY	318202
INJURY AND / OR TOW DUE TO CRASH	97996

Common Values
Length

Value	Count	Frequency (%)
NO INJURY / DRIVE AWAY	318202	76.5%
INJURY AND / OR TOW DUE TO CRASH	97996	23.5%

Length

Max length	32
Median length	22
Mean length	24.3545524
Min length	22

INTERSECTION_RELATED_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	323233
Missing (%)	77.7%
Memory size	3.2 MiB

Y	88558
N	4407
(Missing)	323233

Frequency Table

Value	Count	Frequency (%)
Y	88558	21.3%
N	4407	1.1%
(Missing)	323233	77.7%

HIT_AND_RUN_I
Boolean

MISSING

Distinct count	2
Unique (%)	< 0.1%
Missing	298508
Missing (%)	71.7%
Memory size	3.2 MiB

Y	112568
N	5122
(Missing)	298508

Frequency Table

Value	Count	Frequency (%)
Y	112568	27.0%
N	5122	1.2%
(Missing)	298508	71.7%

DAMAGE
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

OVER $1,500	236574
$501 - $1,500	124480
$500 OR LESS	55144

Common Values
Length

Value	Count	Frequency (%)
OVER $1,500	236574	56.8%
$501 - $1,500	124480	29.9%
$500 OR LESS	55144	13.2%

Length

Max length	13
Median length	11
Mean length	11.73067146
Min length	11

DATE_POLICE_NOTIFIED
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	318866
Unique (%)	76.6%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

02/26/2020 08:30:00 AM	12
09/13/2019 05:00:00 PM	11
01/12/2019 04:30:00 PM	11
02/14/2020 05:00:00 PM	11
06/30/2018 09:30:00 PM	11
Other values (318861)	416142

Common Values
Length

Value	Count	Frequency (%)
02/26/2020 08:30:00 AM	12	< 0.1%
09/13/2019 05:00:00 PM	11	< 0.1%
01/12/2019 04:30:00 PM	11	< 0.1%
02/14/2020 05:00:00 PM	11	< 0.1%
06/30/2018 09:30:00 PM	11	< 0.1%
02/05/2020 05:00:00 PM	10	< 0.1%
05/14/2019 07:00:00 PM	10	< 0.1%
05/31/2019 04:00:00 PM	10	< 0.1%
04/10/2018 03:30:00 PM	10	< 0.1%
10/25/2017 04:30:00 PM	10	< 0.1%
Other values (318856)	416092	> 99.9%

Length

Max length	22
Median length	22
Mean length	22
Min length	22

PRIM_CONTRIBUTORY_CAUSE
Categorical

Distinct count	40
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

UNABLE TO DETERMINE	151188
FAILING TO YIELD RIGHT-OF-WAY	46627
FOLLOWING TOO CLOSELY	45719
NOT APPLICABLE	22450
IMPROPER OVERTAKING/PASSING	20072
Other values (35)	130142

Common Values
Length

Value	Count	Frequency (%)
UNABLE TO DETERMINE	151188	36.3%
FAILING TO YIELD RIGHT-OF-WAY	46627	11.2%
FOLLOWING TOO CLOSELY	45719	11.0%
NOT APPLICABLE	22450	5.4%
IMPROPER OVERTAKING/PASSING	20072	4.8%
IMPROPER BACKING	18724	4.5%
FAILING TO REDUCE SPEED TO AVOID CRASH	17609	4.2%
IMPROPER LANE USAGE	16682	4.0%
IMPROPER TURNING/NO SIGNAL	14033	3.4%
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	12941	3.1%
Other values (30)	50153	12.1%

Length

Max length	80
Median length	19
Mean length	23.72254552
Min length	6

SEC_CONTRIBUTORY_CAUSE
Categorical

Distinct count	40
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

NOT APPLICABLE	167090
UNABLE TO DETERMINE	147957
FAILING TO REDUCE SPEED TO AVOID CRASH	17536
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	13368
FAILING TO YIELD RIGHT-OF-WAY	12833
Other values (35)	57414

Common Values
Length

Value	Count	Frequency (%)
NOT APPLICABLE	167090	40.1%
UNABLE TO DETERMINE	147957	35.5%
FAILING TO REDUCE SPEED TO AVOID CRASH	17536	4.2%
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	13368	3.2%
FAILING TO YIELD RIGHT-OF-WAY	12833	3.1%
FOLLOWING TOO CLOSELY	11846	2.8%
IMPROPER OVERTAKING/PASSING	6243	1.5%
IMPROPER LANE USAGE	6174	1.5%
WEATHER	5338	1.3%
IMPROPER TURNING/NO SIGNAL	4218	1.0%
Other values (30)	23595	5.7%

Length

Max length	80
Median length	19
Mean length	19.71721152
Min length	6

STREET_NO
Real number (ℝ_≥0)

Distinct count	10858
Unique (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3602.1317882354074
Minimum	0
Maximum	451100
Zeros	2
Zeros (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	133
Q1	1200
median	3119
Q3	5504
95-th percentile	8755
Maximum	451100
Range	451100
Interquartile range (IQR)	4304

Descriptive statistics

Standard deviation	2906.652766
Coefficient of variation (CV)	0.8069257141
Kurtosis	1349.602701
Mean	3602.131788
Median Absolute Deviation (MAD)	2118
Skewness	9.468342465
Sum	1499200046
Variance	8448630.299

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
100	2824	0.7%
1600	2614	0.6%
200	2534	0.6%
800	2502	0.6%
300	2345	0.6%
500	2249	0.5%
6300	2107	0.5%
600	2096	0.5%
1200	2060	0.5%
4700	2029	0.5%
Other values (10848)	392838	94.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	1748	0.4%
2	870	0.2%
3	278	0.1%
4	80	< 0.1%

Value	Count	Frequency (%)
451100	1	< 0.1%
34453	1	< 0.1%
13799	3	< 0.1%
13780	1	< 0.1%
13770	13	< 0.1%

STREET_DIRECTION
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	3.2 MiB

W	148717
S	136207
N	102558
E	28714

Common Values
Length

Value	Count	Frequency (%)
W	148717	35.7%
S	136207	32.7%
N	102558	24.6%
E	28714	6.9%
(Missing)	2	< 0.1%

Length

Max length	3
Median length	1
Mean length	1.000009611
Min length	1

STREET_NAME
Categorical

HIGH CARDINALITY

Distinct count	1549
Unique (%)	0.4%
Missing	1
Missing (%)	< 0.1%
Memory size	3.2 MiB

WESTERN AVE	11350
PULASKI RD	9890
CICERO AVE	9035
ASHLAND AVE	8938
HALSTED ST	7898
Other values (1544)	369086

Common Values
Length

Value	Count	Frequency (%)
WESTERN AVE	11350	2.7%
PULASKI RD	9890	2.4%
CICERO AVE	9035	2.2%
ASHLAND AVE	8938	2.1%
HALSTED ST	7898	1.9%
KEDZIE AVE	7011	1.7%
MICHIGAN AVE	5764	1.4%
STATE ST	5115	1.2%
NORTH AVE	4948	1.2%
CLARK ST	4933	1.2%
Other values (1539)	341315	82.0%

Length

Max length	31
Median length	10
Mean length	10.68028438
Min length	3

BEAT_OF_OCCURRENCE
Real number (ℝ_≥0)

Distinct count	275
Unique (%)	0.1%
Missing	4
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	1246.7594775513342
Minimum	111.0
Maximum	6100.0
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	111
5-th percentile	124
Q1	714
median	1214
Q3	1824
95-th percentile	2512
Maximum	6100
Range	5989
Interquartile range (IQR)	1110

Descriptive statistics

Standard deviation	709.4833482
Coefficient of variation (CV)	0.5690619249
Kurtosis	-1.018880184
Mean	1246.759478
Median Absolute Deviation (MAD)	590
Skewness	0.1389000038
Sum	518893814
Variance	503366.6213

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1834	5899	1.4%
122	4728	1.1%
114	4709	1.1%
1831	4688	1.1%
813	4185	1.0%
815	3946	0.9%
833	3357	0.8%
2413	3213	0.8%
1232	3163	0.8%
834	3096	0.7%
Other values (265)	375210	90.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
111	2216	0.5%
112	1626	0.4%
113	1126	0.3%
114	4709	1.1%
121	2453	0.6%

Value	Count	Frequency (%)
6100	1	< 0.1%
2535	1290	0.3%
2534	1702	0.4%
2533	2730	0.7%
2532	1080	0.3%

NUM_UNITS
Real number (ℝ_≥0)

Distinct count	15
Unique (%)	< 0.1%
Missing	1772
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%

Mean	2.021509268240892
Minimum	1.0
Maximum	18.0
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	18
Range	17
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4252291736
Coefficient of variation (CV)	0.2103523245
Kurtosis	38.4143551
Mean	2.021509268
Median Absolute Deviation (MAD)	0
Skewness	3.135685352
Sum	837766
Variance	0.1808198501

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	365967	87.9%
1	23147	5.6%
3	20475	4.9%
4	3600	0.9%
5	851	0.2%
6	233	0.1%
7	92	< 0.1%
8	29	< 0.1%
9	15	< 0.1%
10	9	< 0.1%
Other values (5)	8	< 0.1%
(Missing)	1772	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	23147	5.6%
2	365967	87.9%
3	20475	4.9%
4	3600	0.9%
5	851	0.2%

Value	Count	Frequency (%)
18	1	< 0.1%
16	1	< 0.1%
15	1	< 0.1%
12	2	< 0.1%
11	3	< 0.1%

MOST_SEVERE_INJURY
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing	2669
Missing (%)	0.6%
Memory size	3.2 MiB

NO INDICATION OF INJURY	362524
NONINCAPACITATING INJURY	27954
REPORTED, NOT EVIDENT	16255
INCAPACITATING INJURY	6439
FATAL	357

Common Values
Length

Value	Count	Frequency (%)
NO INDICATION OF INJURY	362524	87.1%
NONINCAPACITATING INJURY	27954	6.7%
REPORTED, NOT EVIDENT	16255	3.9%
INCAPACITATING INJURY	6439	1.5%
FATAL	357	0.1%
(Missing)	2669	0.6%

Length

Max length	24
Median length	23
Mean length	22.81441525
Min length	3

INJURIES_TOTAL
Real number (ℝ_≥0)

ZEROS

Distinct count	18
Unique (%)	< 0.1%
Missing	2662
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	0.16713659753927107
Minimum	0.0
Maximum	21.0
Zeros	362531
Zeros (%)	87.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5297513676
Coefficient of variation (CV)	3.169571329
Kurtosis	56.39700708
Mean	0.1671365975
Median Absolute Deviation (MAD)	0
Skewness	5.267008107
Sum	69117
Variance	0.2806365115

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	362531	87.1%
1	39134	9.4%
2	8066	1.9%
3	2403	0.6%
4	864	0.2%
5	317	0.1%
6	122	< 0.1%
7	47	< 0.1%
9	15	< 0.1%
8	15	< 0.1%
Other values (8)	22	< 0.1%
(Missing)	2662	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	362531	87.1%
1	39134	9.4%
2	8066	1.9%
3	2403	0.6%
4	864	0.2%

Value	Count	Frequency (%)
21	2	< 0.1%
19	1	< 0.1%
16	1	< 0.1%
15	3	< 0.1%
13	2	< 0.1%

INJURIES_FATAL
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	2662
Missing (%)	0.6%
Memory size	3.2 MiB

0	413179
1	333
2	20
3	4

Common Values
Length

Value	Count	Frequency (%)
0	413179	99.3%
1	333	0.1%
2	20	< 0.1%
3	4	< 0.1%
(Missing)	2662	0.6%

Length

Max length	3
Median length	3
Mean length	3
Min length	3

INJURIES_INCAPACITATING
Real number (ℝ_≥0)

ZEROS

Distinct count	8
Unique (%)	< 0.1%
Missing	2662
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	0.01826443163352163
Minimum	0.0
Maximum	7.0
Zeros	407047
Zeros (%)	97.8%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1580884453
Coefficient of variation (CV)	8.655535988
Kurtosis	192.6168951
Mean	0.01826443163
Median Absolute Deviation (MAD)	0
Skewness	11.61566853
Sum	7553
Variance	0.02499195654

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	407047	97.8%
1	5713	1.4%
2	570	0.1%
3	143	< 0.1%
4	49	< 0.1%
5	11	< 0.1%
7	2	< 0.1%
6	1	< 0.1%
(Missing)	2662	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	407047	97.8%
1	5713	1.4%
2	570	0.1%
3	143	< 0.1%
4	49	< 0.1%

Value	Count	Frequency (%)
7	2	< 0.1%
6	1	< 0.1%
5	11	< 0.1%
4	49	< 0.1%
3	143	< 0.1%

INJURIES_NON_INCAPACITATING
Real number (ℝ_≥0)

ZEROS

Distinct count	16
Unique (%)	< 0.1%
Missing	2662
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	0.09160024762052155
Minimum	0.0
Maximum	21.0
Zeros	384446
Zeros (%)	92.4%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	21
Range	21
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3898124196
Coefficient of variation (CV)	4.255582596
Kurtosis	120.6937507
Mean	0.09160024762
Median Absolute Deviation (MAD)	0
Skewness	7.336284575
Sum	37880
Variance	0.1519537225

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	384446	92.4%
1	23281	5.6%
2	3975	1.0%
3	1169	0.3%
4	423	0.1%
5	142	< 0.1%
6	58	< 0.1%
7	19	< 0.1%
8	6	< 0.1%
10	5	< 0.1%
Other values (6)	12	< 0.1%
(Missing)	2662	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	384446	92.4%
1	23281	5.6%
2	3975	1.0%
3	1169	0.3%
4	423	0.1%

Value	Count	Frequency (%)
21	2	< 0.1%
18	1	< 0.1%
16	1	< 0.1%
14	1	< 0.1%
11	4	< 0.1%

INJURIES_REPORTED_NOT_EVIDENT
Real number (ℝ_≥0)

ZEROS

Distinct count	12
Unique (%)	< 0.1%
Missing	2662
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	0.056340923160256906
Minimum	0.0
Maximum	11.0
Zeros	395564
Zeros (%)	95.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3022171841
Coefficient of variation (CV)	5.364079378
Kurtosis	98.97241035
Mean	0.05634092316
Median Absolute Deviation (MAD)	0
Skewness	7.930155486
Sum	23299
Variance	0.09133522636

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	395564	95.0%
1	14222	3.4%
2	2729	0.7%
3	689	0.2%
4	206	< 0.1%
5	84	< 0.1%
6	17	< 0.1%
7	10	< 0.1%
8	5	< 0.1%
9	5	< 0.1%
Other values (2)	5	< 0.1%
(Missing)	2662	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	395564	95.0%
1	14222	3.4%
2	2729	0.7%
3	689	0.2%
4	206	< 0.1%

Value	Count	Frequency (%)
11	1	< 0.1%
10	4	< 0.1%
9	5	< 0.1%
8	5	< 0.1%
7	10	< 0.1%

INJURIES_NO_INDICATION
Real number (ℝ_≥0)

ZEROS

Distinct count	42
Unique (%)	< 0.1%
Missing	2662
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%

Mean	2.017824324847172
Minimum	0.0
Maximum	61.0
Zeros	7217
Zeros (%)	1.7%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	4
Maximum	61
Range	61
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.156723458
Coefficient of variation (CV)	0.5732528067
Kurtosis	88.06257539
Mean	2.017824325
Median Absolute Deviation (MAD)	1
Skewness	4.289878612
Sum	834443
Variance	1.338009157

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	198400	47.7%
1	122973	29.5%
3	51478	12.4%
4	19414	4.7%
5	8103	1.9%
0	7217	1.7%
6	3434	0.8%
7	1306	0.3%
8	596	0.1%
9	242	0.1%
Other values (32)	373	0.1%
(Missing)	2662	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7217	1.7%
1	122973	29.5%
2	198400	47.7%
3	51478	12.4%
4	19414	4.7%

Value	Count	Frequency (%)
61	1	< 0.1%
50	1	< 0.1%
45	1	< 0.1%
42	3	< 0.1%
40	2	< 0.1%

INJURIES_UNKNOWN
Boolean

Distinct count	1
Unique (%)	< 0.1%
Missing	2662
Missing (%)	0.6%
Memory size	3.2 MiB

0	413536
(Missing)	2662

Frequency Table

Value	Count	Frequency (%)
0	413536	99.4%
(Missing)	2662	0.6%

CRASH_HOUR
Real number (ℝ_≥0)

ZEROS

Distinct count	24
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13.192122499387311
Minimum	0
Maximum	23
Zeros	7955
Zeros (%)	1.9%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	9
median	14
Q3	17
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.466229452
Coefficient of variation (CV)	0.4143555711
Kurtosis	-0.3949940867
Mean	13.1921225
Median Absolute Deviation (MAD)	4
Skewness	-0.3972465967
Sum	5490535
Variance	29.87966442

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
16	31862	7.7%
15	31777	7.6%
17	31499	7.6%
14	28035	6.7%
18	25945	6.2%
13	25468	6.1%
12	24434	5.9%
8	23482	5.6%
11	21028	5.1%
9	20013	4.8%
Other values (14)	152655	36.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7955	1.9%
1	6789	1.6%
2	6029	1.4%
3	4973	1.2%
4	4621	1.1%

Value	Count	Frequency (%)
23	10014	2.4%
22	12149	2.9%
21	13130	3.2%
20	14633	3.5%
19	18707	4.5%

CRASH_DAY_OF_WEEK
Real number (ℝ_≥0)

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.124536879081591
Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.969188807
Coefficient of variation (CV)	0.477432707
Kurtosis	-1.23070302
Mean	4.124536879
Median Absolute Deviation (MAD)	2
Skewness	-0.0721495666
Sum	1716624
Variance	3.877704559

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	67592	16.2%
7	60950	14.6%
3	60300	14.5%
5	59884	14.4%
4	59524	14.3%
2	58058	13.9%
1	49890	12.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	49890	12.0%
2	58058	13.9%
3	60300	14.5%
4	59524	14.3%
5	59884	14.4%

Value	Count	Frequency (%)
7	60950	14.6%
6	67592	16.2%
5	59884	14.4%
4	59524	14.3%
3	60300	14.5%

CRASH_MONTH
Real number (ℝ_≥0)

Distinct count	12
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.601134556148756
Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.469570701
Coefficient of variation (CV)	0.5256021782
Kurtosis	-1.224863741
Mean	6.601134556
Median Absolute Deviation (MAD)	3
Skewness	-0.03463350759
Sum	2747379
Variance	12.03792085

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	38043	9.1%
6	37690	9.1%
12	36913	8.9%
5	36717	8.8%
11	35832	8.6%
9	34951	8.4%
1	34372	8.3%
3	33651	8.1%
2	32917	7.9%
8	32646	7.8%
Other values (2)	62466	15.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	34372	8.3%
2	32917	7.9%
3	33651	8.1%
4	31344	7.5%
5	36717	8.8%

Value	Count	Frequency (%)
12	36913	8.9%
11	35832	8.6%
10	38043	9.1%
9	34951	8.4%
8	32646	7.8%

LATITUDE
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct count	188507
Unique (%)	45.5%
Missing	2269
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%

Mean	41.85715475635502
Minimum	0.0
Maximum	42.022779861
Zeros	29
Zeros (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	41.71443216
Q1	41.78658293
median	41.877441
Q3	41.92475429
95-th percentile	41.9903545
Maximum	42.02277986
Range	42.02277986
Interquartile range (IQR)	0.13817136

Descriptive statistics

Standard deviation	0.3605778004
Coefficient of variation (CV)	0.008614484251
Kurtosis	12719.21078
Mean	41.85715476
Median Absolute Deviation (MAD)	0.06766827
Skewness	-109.5963231
Sum	17325890.21
Variance	0.1300163502

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
41.97620114	553	0.1%
41.79142028	274	0.1%
41.7514606	270	0.1%
41.72225727	223	0.1%
41.78932932	204	< 0.1%
41.75466012	194	< 0.1%
41.90095892	177	< 0.1%
41.74257762	151	< 0.1%
41.73638005	147	< 0.1%
41.79291088	141	< 0.1%
Other values (188497)	411595	98.9%
(Missing)	2269	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	29	< 0.1%
41.64467013	11	< 0.1%
41.64469152	2	< 0.1%
41.64469397	5	< 0.1%
41.64470194	1	< 0.1%

Value	Count	Frequency (%)
42.02277986	3	< 0.1%
42.02273632	1	< 0.1%
42.02272017	1	< 0.1%
42.02266893	1	< 0.1%
42.02266114	2	< 0.1%

LONGITUDE
Real number (ℝ)

HIGH CORRELATION
SKEWED

Distinct count	188492
Unique (%)	45.5%
Missing	2269
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%

Mean	-87.6721175590124
Minimum	-87.934014222
Maximum	0.0
Zeros	29
Zeros (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	-87.93401422
5-th percentile	-87.77636157
Q1	-87.72079453
median	-87.67297631
Q3	-87.63296444
95-th percentile	-87.58608853
Maximum	0
Range	87.93401422
Interquartile range (IQR)	0.087830094

Descriptive statistics

Standard deviation	0.7361749743
Coefficient of variation (CV)	-0.008396911069
Kurtosis	14089.92941
Mean	-87.67211756
Median Absolute Deviation (MAD)	0.042428613
Skewness	118.3356283
Sum	-36290031.95
Variance	0.5419535928

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-87.90530913	553	0.1%
-87.58014777	274	0.1%
-87.58597199	270	0.1%
-87.58527557	223	0.1%
-87.74164564	204	< 0.1%
-87.74138476	194	< 0.1%
-87.61992817	177	< 0.1%
-87.63393693	151	< 0.1%
-87.62750922	147	< 0.1%
-87.74207734	141	< 0.1%
Other values (188482)	411595	98.9%
(Missing)	2269	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-87.93401422	1	< 0.1%
-87.93399393	15	< 0.1%
-87.9339765	1	< 0.1%
-87.93302828	2	< 0.1%
-87.92726168	3	< 0.1%

Value	Count	Frequency (%)
0	29	< 0.1%
-87.52458739	3	< 0.1%
-87.52458901	2	< 0.1%
-87.52464032	1	< 0.1%
-87.52467395	4	< 0.1%

LOCATION
Categorical

HIGH CARDINALITY

Distinct count	188585
Unique (%)	45.6%
Missing	2269
Missing (%)	0.5%
Memory size	3.2 MiB

POINT (-87.905309125103 41.976201139024)	553
POINT (-87.580147768689 41.791420282098)	274
POINT (-87.585971992965 41.751460603167)	270
POINT (-87.585275565077 41.722257273006)	223
POINT (-87.741645644196 41.789329323265)	204
Other values (188580)	412405

Common Values
Length

Value	Count	Frequency (%)
POINT (-87.905309125103 41.976201139024)	553	0.1%
POINT (-87.580147768689 41.791420282098)	274	0.1%
POINT (-87.585971992965 41.751460603167)	270	0.1%
POINT (-87.585275565077 41.722257273006)	223	0.1%
POINT (-87.741645644196 41.789329323265)	204	< 0.1%
POINT (-87.741384758605 41.754660124394)	194	< 0.1%
POINT (-87.619928173678 41.900958919109)	177	< 0.1%
POINT (-87.633936930688 41.742577617335)	151	< 0.1%
POINT (-87.627509219026 41.736380045588)	147	< 0.1%
POINT (-87.742077342959 41.792910883497)	141	< 0.1%
Other values (188575)	411595	98.9%
(Missing)	2269	0.5%

Length

Max length	40
Median length	40
Mean length	39.57757846
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	CRASH_RECORD_ID	RD_NO	CRASH_DATE	POSTED_SPEED_LIMIT	TRAFFIC_CONTROL_DEVICE	DEVICE_CONDITION	WEATHER_CONDITION	LIGHTING_CONDITION	FIRST_CRASH_TYPE	TRAFFICWAY_TYPE	LANE_CNT	ALIGNMENT	ROADWAY_SURFACE_COND	ROAD_DEFECT	REPORT_TYPE	CRASH_TYPE	INTERSECTION_RELATED_I	HIT_AND_RUN_I	DAMAGE	DATE_POLICE_NOTIFIED	PRIM_CONTRIBUTORY_CAUSE	SEC_CONTRIBUTORY_CAUSE	STREET_NO	STREET_DIRECTION	STREET_NAME	BEAT_OF_OCCURRENCE	NUM_UNITS	MOST_SEVERE_INJURY	INJURIES_TOTAL	INJURIES_NON_INCAPACITATING	INJURIES_NO_INDICATION	CRASH_HOUR	CRASH_DAY_OF_WEEK	CRASH_MONTH	LATITUDE	LONGITUDE	LOCATION
0	073682ef84ff827659552d4254ad1b98bfec24935cc9cc4cbb796b0d17f98ce6028f4ac1795c51cdfa6cb6933de709f33cfe5171c175e4a0f5aebda62f2f61ce	JB460108	10/02/2018 06:30:00 PM	10	NO CONTROLS	NO CONTROLS	CLEAR	DARKNESS	PARKED MOTOR VEHICLE	OTHER	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	NaN	NaN	OVER $1,500	10/02/2018 07:35:00 PM	NOT APPLICABLE	NOT APPLICABLE	517	W	OHARE ST	1654.0	2.0	NO INDICATION OF INJURY	0.0	0.0	1.0	18	3	10	NaN	NaN	NaN
1	1560fb8a1e32b528fef8bfd677d2b3fc5ab37278b157fa5ecf66064359bdad3803b9d298d234eb31f463d08515c791b5627fbf7afea3765d1c1a9f3befc5bdcc	JC325941	06/27/2019 04:00:00 PM	45	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	ONE-WAY	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	NaN	NaN	OVER $1,500	06/27/2019 04:00:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	3	W	TERMINAL ST	1653.0	2.0	NO INDICATION OF INJURY	0.0	0.0	2.0	16	5	6	NaN	NaN	NaN
2	009e9e67203442370272e1a13d6ee51a4155dac65e583d1bdbee1fde686de7508c14ab5f205402f72644001276718917e02985561dc71b7d4bf945f09d7d47f5	JA329216	06/30/2017 04:00:00 PM	35	STOP SIGN/FLASHER	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	TURNING	NOT DIVIDED	4.0	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	Y	NaN	OVER $1,500	06/30/2017 04:01:00 PM	FAILING TO YIELD RIGHT-OF-WAY	NOT APPLICABLE	8301	S	CICERO AVE	834.0	2.0	NO INDICATION OF INJURY	0.0	0.0	3.0	16	6	6	41.741804	-87.740954	POINT (-87.740953581987 41.741803598989)
3	00e47f189660cd8ba1e85fc63061bf1d8465184393f134fb8251ed7896a4ba9ed7c984ab51a01f564d6f4133c6ef8493b1a369743a4a308d4392900a286e160f	JC194776	03/21/2019 10:50:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DARKNESS, LIGHTED ROAD	TURNING	NOT DIVIDED	4.0	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	Y	NaN	OVER $1,500	03/21/2019 10:52:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	8301	S	CICERO AVE	834.0	2.0	NO INDICATION OF INJURY	0.0	0.0	2.0	22	5	3	41.741804	-87.740954	POINT (-87.740953581987 41.741803598989)
4	0126747fc9ffc0edc9a38abb83d80034f897db0f739eef57f9bc75de8f2702a4c8f6dd8e49f5c2e810e1ec428bd9532fd0e6c583ca72669da9e65fc2a0a6de12	JB200478	03/26/2018 02:23:00 PM	35	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	PARKED MOTOR VEHICLE	NOT DIVIDED	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	NaN	NaN	$501 - $1,500	03/26/2018 03:20:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	3999	N	AVONDALE AVE	1732.0	2.0	NO INDICATION OF INJURY	0.0	0.0	2.0	14	2	3	41.953647	-87.732082	POINT (-87.732081736006 41.953646899951)
5	5d672ce84d5b78346be822b388604bdf9cb3fa348a5adc89501859f857e1e9308e35ececb0a56527c6e6d065cc85e4e93302c1c57a97068034116e8b23ec2f4e	JD158927	02/20/2020 04:45:00 PM	35	TRAFFIC SIGNAL	OTHER	CLEAR	DAWN	REAR END	T-INTERSECTION	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	Y	NaN	$501 - $1,500	02/20/2020 04:51:00 PM	NOT APPLICABLE	NOT APPLICABLE	12300	W	IRVING PARK RD	1654.0	2.0	NO INDICATION OF INJURY	0.0	0.0	2.0	16	5	2	41.958987	-87.933994	POINT (-87.933993928974 41.958986950953)
6	0209e21f298984f7375742b7ef27c9880b485f41123a12b5a8eb14f01171abbbc05974399b985e05a352f801869cae0f41587f39a51994338fb82aeba853eece	JB415436	08/30/2018 05:45:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	TURNING	NOT DIVIDED	NaN	STRAIGHT AND LEVEL	DRY	UNKNOWN	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	Y	NaN	OVER $1,500	08/30/2018 05:58:00 PM	IMPROPER OVERTAKING/PASSING	IMPROPER LANE USAGE	600	W	DIVISION ST	1822.0	2.0	NO INDICATION OF INJURY	0.0	0.0	2.0	17	5	8	41.903825	-87.643286	POINT (-87.643286359995 41.903825233976)
7	0211e1f766f3940dfa87375661d25b716655e908c320cc46910e8fa5fb1f1e6a9d4f714d21e8e401ec9e0a12190b6cd9f6dbc97d32d0c0fc966a02ae516e782f	JC301403	06/11/2019 08:40:00 AM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	REAR END	DIVIDED - W/MEDIAN BARRIER	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	Y	NaN	$501 - $1,500	06/11/2019 09:05:00 AM	UNABLE TO DETERMINE	NOT APPLICABLE	50	E	GARFIELD BLVD	225.0	2.0	NO INDICATION OF INJURY	0.0	0.0	3.0	8	3	6	41.794779	-87.623828	POINT (-87.623828038036 41.794778764028)
8	02e2ed3606a50dda185f5e97c57a45552087d6fbea1c4b5f3777e0503da72279211f0518aabbeca2cd8e8ee1aca6cae3f88a0531cb62bb39ac156ca3d55e0931	JB256393	05/09/2018 11:30:00 AM	25	NO CONTROLS	NO CONTROLS	RAIN	DAYLIGHT	ANGLE	NOT DIVIDED	2.0	STRAIGHT AND LEVEL	WET	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	NaN	NaN	OVER $1,500	05/09/2018 11:35:00 AM	FAILING TO YIELD RIGHT-OF-WAY	UNABLE TO DETERMINE	9511	S	WENTWORTH AVE	511.0	2.0	NO INDICATION OF INJURY	0.0	0.0	2.0	11	4	5	41.721290	-87.628510	POINT (-87.628509593966 41.72128957001)
9	03c8fee8a0cb0d303e972a873228b444a47b7b1ed1e2d97a8c409203dc81a9d97abc26692d325af7428a2f8f880ab0e551e763782226b9b6a0c3e19abd7ffa23	JB317419	06/22/2018 07:25:00 AM	35	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	RAIN	DAYLIGHT	TURNING	NOT DIVIDED	6.0	STRAIGHT AND LEVEL	WET	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	Y	NaN	OVER $1,500	06/22/2018 07:27:00 AM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	8301	S	CICERO AVE	834.0	2.0	NONINCAPACITATING INJURY	2.0	2.0	2.0	7	6	6	41.741804	-87.740954	POINT (-87.740953581987 41.741803598989)

Last rows

	CRASH_RECORD_ID	RD_NO	CRASH_DATE	POSTED_SPEED_LIMIT	TRAFFIC_CONTROL_DEVICE	DEVICE_CONDITION	WEATHER_CONDITION	LIGHTING_CONDITION	FIRST_CRASH_TYPE	TRAFFICWAY_TYPE	LANE_CNT	ALIGNMENT	ROADWAY_SURFACE_COND	ROAD_DEFECT	REPORT_TYPE	CRASH_TYPE	INTERSECTION_RELATED_I	HIT_AND_RUN_I	DAMAGE	DATE_POLICE_NOTIFIED	PRIM_CONTRIBUTORY_CAUSE	SEC_CONTRIBUTORY_CAUSE	STREET_NO	STREET_DIRECTION	STREET_NAME	BEAT_OF_OCCURRENCE	NUM_UNITS	MOST_SEVERE_INJURY	INJURIES_NO_INDICATION	CRASH_HOUR	CRASH_DAY_OF_WEEK	CRASH_MONTH	LATITUDE	LONGITUDE	LOCATION
416188	e03b02d64d5d4db07c0c24fe1e9c495b4ac5b67cbe1e7334d16533b47b2a410bf1481830ec85ab046c4b391bf689476f68af6df1437f9e21cd10cacb10f7308a	JD236641	05/19/2020 01:00:00 PM	25	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	REAR END	ONE-WAY	NaN	STRAIGHT AND LEVEL	WET	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	NaN	Y	$501 - $1,500	05/19/2020 02:30:00 PM	NOT APPLICABLE	NOT APPLICABLE	1000	S	KOLMAR AVE	1131.0	2.0	NO INDICATION OF INJURY	2.0	13	3	5	41.869118	-87.739401	POINT (-87.739401314183 41.869117777281)
416189	f198c65371434926c14b2a63ed8792a1389fadaf675d8ee368dc5aaf1a30467a894c1412b2f099985c04308755ad76dfd1589de86c674ff6050c527539baee0d	JD236802	05/19/2020 03:31:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	TURNING	FOUR WAY	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	Y	NaN	$501 - $1,500	05/19/2020 03:51:00 PM	IMPROPER TURNING/NO SIGNAL	NOT APPLICABLE	2001	E	MARQUETTE DR	331.0	2.0	NO INDICATION OF INJURY	2.0	15	3	5	41.775563	-87.576444	POINT (-87.576444451178 41.775562727526)
416190	f52f00333e5cac1530939b110da25a72de89372c032ae422467081eb937a8ff841ff2f5d73c28ededd41b765fad1e5681c1b039b5c02435bb9edb9ee97c94eab	JD236940	05/19/2020 06:21:00 PM	30	NO CONTROLS	NO CONTROLS	CLOUDY/OVERCAST	DAYLIGHT	SIDESWIPE SAME DIRECTION	DIVIDED - W/MEDIAN (NOT RAISED)	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	NaN	NaN	$500 OR LESS	05/19/2020 06:21:00 PM	FAILING TO YIELD RIGHT-OF-WAY	NOT APPLICABLE	2473	N	CLARK ST	1935.0	2.0	NO INDICATION OF INJURY	3.0	18	3	5	41.927478	-87.641450	POINT (-87.641449775903 41.927477726852)
416191	d97477e587b8eecbdb0dbce0a0c5462e7335a4f7da2e04c8e4799193cba69f0b887de56a831e8899031c1f7175e82a2ad8c43ba34260181a3e4e1bafda37ea88	JD234027	05/16/2020 11:45:00 AM	40	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	DIVIDED - W/MEDIAN BARRIER	NaN	CURVE, LEVEL	DRY	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	NaN	NaN	OVER $1,500	05/16/2020 11:55:00 AM	FAILING TO YIELD RIGHT-OF-WAY	NOT APPLICABLE	120	N	LAKE SHORE DR SB	114.0	2.0	NO INDICATION OF INJURY	2.0	11	7	5	41.883642	-87.615441	POINT (-87.615441182232 41.883641778749)
416192	e43ffefbcb0c4518869aac0447be15af688b10f56d652adb93a204fc18d823594c6cf5e64bcf12134ee2e91a692e0434118a1367b5a5904e448f4cdbc850bfb5	JD234946	05/17/2020 01:22:00 PM	30	NO CONTROLS	NO CONTROLS	RAIN	DAYLIGHT	PARKED MOTOR VEHICLE	DIVIDED - W/MEDIAN BARRIER	NaN	STRAIGHT AND LEVEL	WET	UNKNOWN	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	NaN	NaN	$501 - $1,500	05/17/2020 01:22:00 PM	IMPROPER LANE USAGE	FAILING TO REDUCE SPEED TO AVOID CRASH	1924	W	GARFIELD BLVD	932.0	3.0	NO INDICATION OF INJURY	1.0	13	1	5	41.794040	-87.673019	POINT (-87.673018619292 41.79403960152)
416193	de4cbde297443228427759c6d58f40254dc8d8fcb201dc731da85d4d0dcd05fd2fbb10974bc0d17cdecd4128959af5b2fc2a4b8a0ee42f3370be201aba68a5bd	JD235651	05/18/2020 12:20:00 PM	10	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	REAR TO SIDE	PARKING LOT	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	NaN	NaN	$500 OR LESS	05/18/2020 12:32:00 PM	FAILING TO YIELD RIGHT-OF-WAY	UNABLE TO DETERMINE	1527	W	LAWRENCE AVE	1912.0	2.0	NO INDICATION OF INJURY	2.0	12	2	5	41.968773	-87.668624	POINT (-87.668624408172 41.968772794281)
416194	eb65bb1c2f912fbd1a80406813bbe831df2083d483334697387d443e911400cfad731b727f3ab2ab982ab9583e12ef1bba31838e50a2d4c3979a28223b8ef00f	JD235725	05/18/2020 09:00:00 AM	30	UNKNOWN	UNKNOWN	UNKNOWN	UNKNOWN	PARKED MOTOR VEHICLE	UNKNOWN	NaN	STRAIGHT AND LEVEL	UNKNOWN	UNKNOWN	NOT ON SCENE (DESK REPORT)	INJURY AND / OR TOW DUE TO CRASH	NaN	Y	OVER $1,500	05/18/2020 01:48:00 PM	UNABLE TO DETERMINE	NOT APPLICABLE	4015	N	PARKSIDE AVE	1624.0	2.0	NO INDICATION OF INJURY	1.0	9	2	5	41.953658	-87.768095	POINT (-87.768095363598 41.953657967626)
416195	d35263055740651327a467ea3b5181fde21e1edad1e917c4096a7ca360f3ef47a2d3dc69666c6fc9bdfe7a9fdf8420654f251fcdf7c657bddc51a3a263e6eaf5	JD236504	05/19/2020 02:00:00 AM	20	NO CONTROLS	NO CONTROLS	RAIN	DARKNESS, LIGHTED ROAD	PARKED MOTOR VEHICLE	ONE-WAY	NaN	STRAIGHT AND LEVEL	WET	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	NaN	NaN	$500 OR LESS	05/19/2020 11:00:00 AM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	5700	N	RICHMOND ST	2011.0	2.0	NO INDICATION OF INJURY	1.0	2	3	5	41.985008	-87.703007	POINT (-87.70300710512 41.985008248097)
416196	d613f48076a4221ebaebf9fc31bf396baaf18892529f3f97474e6795d01eb9545440ed9dc0d31201c554798cce001416f0aff7f4214f3848bdb211d8f89915af	JD236487	05/19/2020 09:40:00 AM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	PARKED MOTOR VEHICLE	NOT DIVIDED	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	NaN	NaN	$501 - $1,500	05/19/2020 10:36:00 AM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	7715	S	COTTAGE GROVE AVE	624.0	2.0	NO INDICATION OF INJURY	1.0	9	3	5	41.754447	-87.605136	POINT (-87.605136112415 41.75444668619)
416197	f247683bbffde5cd7d1bddad30ff42c2d3d4594ffd218dc9bdbb270b88edac4d3e2c87a077ea21bede21d27eb2d508c8c9e0a42595a81d1221035e85aeea04cd	JD236796	05/19/2020 01:32:00 PM	10	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	OTHER OBJECT	ALLEY	NaN	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	NaN	NaN	OVER $1,500	05/19/2020 03:46:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	925	S	INDEPENDENCE BLVD	1133.0	1.0	NO INDICATION OF INJURY	1.0	13	3	5	41.869263	-87.719477	POINT (-87.719476770345 41.869263306188)

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows